<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page contentType="application/msexcel; charset=UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<%@ taglib uri="http://struts.apache.org/tags-logic" prefix="logic"%>
<%@ taglib uri="http://struts.apache.org/tags-tiles" prefix="tiles"%>
<%@ taglib uri="http://jsptags.com/tags/navigation/pager" prefix="pg"%>
<%  response.setHeader("Content-disposition","inline; filename = "+new String( "公司收费年汇总表".getBytes("gb2312"), "ISO8859-1" )+".xls");%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>公司收费年汇总</title>
<LINK href="images/css.css" type="text/css" rel="stylesheet">
</head>

<body>
<table align="center" width="80%" border="0">
	<tr>
		<td class="STYLE4" align="center" bgcolor="#ffffff" height="40">公司收费年汇总(${year
		}年) 单位:元</td>
	</tr>
	<tr>
		<td>
		<table align="center" class="tableline" cellspacing="1"
			cellpadding="0" width="100%" border="1">
			<tr>
				<td width="10%" align="center" bgcolor="#ffffff">小区</td>
				<td width="10%" align="center" bgcolor="#ffffff">应缴金额</td>
				<td width="10%" align="center" bgcolor="#ffffff">实收金额</td>
				<td width="10%" align="center" bgcolor="#ffffff">物业服务费</td>
				<td width="10%" height="26" align="center" bgcolor="#ffffff">
				电费</td>
				<td width="10%" align="center" bgcolor="#ffffff">水费</td>
				<td width="10%" align="center" bgcolor="#ffffff">停车服务费</td>
				<td width="10%" align="center" bgcolor="#ffffff">垃圾清运费</td>
				<td width="10%" align="center" bgcolor="#ffffff">路灯电费</td>
				<td width="10%" align="center" bgcolor="#ffffff">二次提水电费</td>
			</tr>
			<c:forEach items="${queryList }" var="queryMap">
				<tr>
					<td width="10%" align="center" bgcolor="#ffffff">
					${queryMap.sub.name }</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.totalSum }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.paidSum }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.propCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.powerCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.waterCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.carCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.rubbishCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.lightCharge }" pattern="0.00" />&nbsp;</td>
					<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
						value="${queryMap.water2ndCharge }" pattern="0.00" />&nbsp;</td>
				</tr>
			</c:forEach>
			<tr>
				<td width="10%" align="center" bgcolor="#ffffff">总计:</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${totalSumRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${paidSumRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${propChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${powerChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${waterChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${carChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${rubbishChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${lightChargeRet }" pattern="0.00" />&nbsp;</td>
				<td width="10%" align="right" bgcolor="#ffffff"><fmt:formatNumber
					value="${water2ndChargeRet }" pattern="0.00" />&nbsp;</td>
			</tr>
		</table>
		</td>
	</tr>
</table>
</body>
</html>